dance analysis

Dataset statistics

Number of variables	29
Number of observations	9999
Missing cells	92654
Missing cells (%)	32.0%
Duplicate rows	3
Duplicate rows (%)	< 0.1%
Total size in memory	2.2 MiB
Average record size in memory	232.0 B

Variable types

Categorical	14
Numeric	15

Alerts

`event` has constant value "Vehicle Connected"	Constant
Dataset has 3 (< 0.1%) duplicate rows	Duplicates
`vehicle_id` has a high cardinality: 3421 distinct values	High cardinality
`user_id` has a high cardinality: 3454 distinct values	High cardinality
`occurred_at_time` has a high cardinality: 9718 distinct values	High cardinality
`app_version` has a high cardinality: 107 distinct values	High cardinality
`battery_cells` has a high cardinality: 782 distinct values	High cardinality
`battery_serial_number` has a high cardinality: 4408 distinct values	High cardinality
`hmi_serial_number` has a high cardinality: 3589 distinct values	High cardinality
`battery_error_state` is highly overall correlated with `versions_mc_firmware`	High correlation
`battery_state_battery_soc` is highly overall correlated with `battery_state_pack_voltage` and 1 other fields	High correlation
`battery_state_cell_temp_1` is highly overall correlated with `battery_state_cell_temp_2` and 6 other fields	High correlation
`battery_state_cell_temp_2` is highly overall correlated with `battery_state_cell_temp_1` and 6 other fields	High correlation
`battery_state_chg_temp` is highly overall correlated with `battery_state_cell_temp_1` and 6 other fields	High correlation
`battery_state_dsg_temp` is highly overall correlated with `battery_state_cell_temp_1` and 6 other fields	High correlation
`battery_state_full_capacity` is highly overall correlated with `battery_state_cell_temp_1` and 8 other fields	High correlation
`battery_state_pack_voltage` is highly overall correlated with `battery_state_battery_soc` and 2 other fields	High correlation
`battery_state_pre_start_temp` is highly overall correlated with `battery_state_cell_temp_1` and 6 other fields	High correlation
`battery_state_remaining_capacity` is highly overall correlated with `battery_state_cell_temp_1` and 6 other fields	High correlation
`remaining_mileage` is highly overall correlated with `battery_state_battery_soc` and 1 other fields	High correlation
`versions_mc_firmware` is highly overall correlated with `battery_error_state`	High correlation
`os_name` is highly overall correlated with `battery_state_cell_temp_1` and 7 other fields	High correlation
`versions_battery_firmware` is highly overall correlated with `battery_state_full_capacity` and 1 other fields	High correlation
`versions_hmi_firmware` is highly overall correlated with `battery_state_full_capacity` and 2 other fields	High correlation
`versions_hmi_hardware` is highly overall correlated with `versions_hmi_firmware`	High correlation
`versions_mc_firmware` is highly imbalanced (96.5%)	Imbalance
`os_name` is highly imbalanced (62.4%)	Imbalance
`versions_battery_firmware` is highly imbalanced (50.1%)	Imbalance
`total_mileage` has 1684 (16.8%) missing values	Missing
`versions_mc_firmware` has 2026 (20.3%) missing values	Missing
`assist_level` has 1798 (18.0%) missing values	Missing
`battery_cells` has 8573 (85.7%) missing values	Missing
`battery_serial_number` has 1925 (19.3%) missing values	Missing
`battery_state_battery_soc` has 1907 (19.1%) missing values	Missing
`battery_state_battery_soh` has 1907 (19.1%) missing values	Missing
`battery_state_cell_temp_1` has 8595 (86.0%) missing values	Missing
`battery_state_cell_temp_2` has 8595 (86.0%) missing values	Missing
`battery_state_chg_temp` has 8595 (86.0%) missing values	Missing
`battery_state_dsg_temp` has 8595 (86.0%) missing values	Missing
`battery_state_full_capacity` has 8595 (86.0%) missing values	Missing
`battery_state_pack_voltage` has 1907 (19.1%) missing values	Missing
`battery_state_pre_start_temp` has 8595 (86.0%) missing values	Missing
`battery_state_real_time_current` has 1907 (19.1%) missing values	Missing
`battery_state_remaining_capacity` has 8595 (86.0%) missing values	Missing
`hmi_serial_number` has 962 (9.6%) missing values	Missing
`remaining_mileage` has 1739 (17.4%) missing values	Missing
`versions_battery_firmware` has 2026 (20.3%) missing values	Missing
`versions_hmi_firmware` has 2026 (20.3%) missing values	Missing
`versions_hmi_hardware` has 2026 (20.3%) missing values	Missing
`total_mileage` is highly skewed (γ1 = 24.03341074)	Skewed
`assist_level` is highly skewed (γ1 = 23.94794415)	Skewed
`remaining_mileage` is highly skewed (γ1 = 28.48081515)	Skewed
`occurred_at_time` is uniformly distributed	Uniform
`assist_level` has 475 (4.8%) zeros	Zeros
`battery_error_state` has 9872 (98.7%) zeros	Zeros
`battery_state_cell_temp_1` has 591 (5.9%) zeros	Zeros
`battery_state_cell_temp_2` has 592 (5.9%) zeros	Zeros
`battery_state_chg_temp` has 594 (5.9%) zeros	Zeros
`battery_state_dsg_temp` has 594 (5.9%) zeros	Zeros
`battery_state_full_capacity` has 591 (5.9%) zeros	Zeros
`battery_state_pre_start_temp` has 594 (5.9%) zeros	Zeros
`battery_state_remaining_capacity` has 591 (5.9%) zeros	Zeros

Reproduction

Analysis started	2023-10-05 19:39:06.590692
Analysis finished	2023-10-05 19:40:25.158049
Duration	1 minute and 18.57 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

vehicle_id
Categorical

Distinct	3421
Distinct (%)	34.2%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

5b3a3fb6-35ff-4d10-957a-68e50b9e9117	84
fd878446-1c44-4a9f-b88f-10ce83cade59	47
382d4727-6119-4391-adc0-ac5500c489b6	47
ca4c5d0d-0d08-4189-b8ee-e8cd4d337422	39
a394bc6d-1c28-42d6-b473-88379f34d6aa	36
Other values (3416)	9746

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Characters and Unicode

Total characters	359964
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1407 ?
Unique (%)	14.1%

Sample

1st row	bc3412f7-37a8-4676-8043-53f4a1bb316a
2nd row	95e7ee01-3987-481a-9000-3b331c52192f
3rd row	c63d60f2-5e2a-483c-bb11-935c45ebf2f0
4th row	79df825d-8115-4a84-9aa8-87ae307ae561
5th row	0d30c889-a102-4bdc-b8a3-c1e0d6c536d5

Common Values

Value	Count	Frequency (%)
5b3a3fb6-35ff-4d10-957a-68e50b9e9117	84	0.8%
fd878446-1c44-4a9f-b88f-10ce83cade59	47	0.5%
382d4727-6119-4391-adc0-ac5500c489b6	47	0.5%
ca4c5d0d-0d08-4189-b8ee-e8cd4d337422	39	0.4%
a394bc6d-1c28-42d6-b473-88379f34d6aa	36	0.4%
8a8278e1-021c-45fc-a485-66e41291b9e7	35	0.4%
6eb63e1f-be68-42e6-9959-f962667b9d64	35	0.4%
4cf2b02f-5631-4441-a93d-a1f2d59c83bf	34	0.3%
9d5c8861-faa8-4c13-960b-88d1cd147917	29	0.3%
df816c87-7f79-4834-9dc5-efc1391c886b	29	0.3%
Other values (3411)	9584	95.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
5b3a3fb6-35ff-4d10-957a-68e50b9e9117	84	0.8%
fd878446-1c44-4a9f-b88f-10ce83cade59	47	0.5%
382d4727-6119-4391-adc0-ac5500c489b6	47	0.5%
ca4c5d0d-0d08-4189-b8ee-e8cd4d337422	39	0.4%
a394bc6d-1c28-42d6-b473-88379f34d6aa	36	0.4%
8a8278e1-021c-45fc-a485-66e41291b9e7	35	0.4%
6eb63e1f-be68-42e6-9959-f962667b9d64	35	0.4%
4cf2b02f-5631-4441-a93d-a1f2d59c83bf	34	0.3%
24205f9c-7987-4984-9755-bd95f3305655	29	0.3%
df816c87-7f79-4834-9dc5-efc1391c886b	29	0.3%
Other values (3411)	9584	95.8%

Most occurring characters

Value	Count	Frequency (%)
-	39996	11.1%
4	28133	7.8%
8	21712	6.0%
9	21415	5.9%
b	21375	5.9%
a	21128	5.9%
1	19365	5.4%
5	19277	5.4%
7	19103	5.3%
3	18812	5.2%
Other values (7)	129648	36.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	202618	56.3%
Lowercase Letter	117350	32.6%
Dash Punctuation	39996	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	28133	13.9%
8	21712	10.7%
9	21415	10.6%
1	19365	9.6%
5	19277	9.5%
7	19103	9.4%
3	18812	9.3%
6	18547	9.2%
0	18280	9.0%
2	17974	8.9%

Lowercase Letter

Value	Count	Frequency (%)
b	21375	18.2%
a	21128	18.0%
c	18801	16.0%
d	18792	16.0%
f	18709	15.9%
e	18545	15.8%

Dash Punctuation

Value	Count	Frequency (%)
-	39996	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	242614	67.4%
Latin	117350	32.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	39996	16.5%
4	28133	11.6%
8	21712	8.9%
9	21415	8.8%
1	19365	8.0%
5	19277	7.9%
7	19103	7.9%
3	18812	7.8%
6	18547	7.6%
0	18280	7.5%

Latin

Value	Count	Frequency (%)
b	21375	18.2%
a	21128	18.0%
c	18801	16.0%
d	18792	16.0%
f	18709	15.9%
e	18545	15.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	359964	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	39996	11.1%
4	28133	7.8%
8	21712	6.0%
9	21415	5.9%
b	21375	5.9%
a	21128	5.9%
1	19365	5.4%
5	19277	5.4%
7	19103	5.3%
3	18812	5.2%
Other values (7)	129648	36.0%

user_id
Categorical

Distinct	3454
Distinct (%)	34.5%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

2d213fa9-1951-4265-8725-5c0992b155c2	93
d453aad8-6c95-425a-8a63-f9fe012554f8	47
b16f77bf-6a58-49b0-8b8f-da7c7058bfbf	47
e9e81cc8-0fef-4a75-a851-7ca7ddfd117b	41
98f8b924-0f17-4285-898e-9b95b6de6162	40
Other values (3449)	9731

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Characters and Unicode

Total characters	359964
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1504 ?
Unique (%)	15.0%

Sample

1st row	ca73adbe-5930-45ba-af74-de5865d8b093
2nd row	6560e385-b90d-42be-b977-5cdb3a5d5a60
3rd row	118047dc-bf44-4dc0-9862-0cb3ac5db65d
4th row	f0c0ac6d-32a1-45ed-9de1-466455fa637a
5th row	2b9f8b3f-b3f3-409b-ade0-dd9ae8b54ba7

Common Values

Value	Count	Frequency (%)
2d213fa9-1951-4265-8725-5c0992b155c2	93	0.9%
d453aad8-6c95-425a-8a63-f9fe012554f8	47	0.5%
b16f77bf-6a58-49b0-8b8f-da7c7058bfbf	47	0.5%
e9e81cc8-0fef-4a75-a851-7ca7ddfd117b	41	0.4%
98f8b924-0f17-4285-898e-9b95b6de6162	40	0.4%
1b50bc7e-15c5-4ae7-822e-9b29988adf7b	38	0.4%
7d7c1e29-1a35-447c-b672-5899a55bc6f1	38	0.4%
44ebfb1a-9cfe-4791-8fc3-f8e5a0ff9b74	38	0.4%
2aef8afc-6d81-4c4b-b103-9bd4db52fe61	37	0.4%
86ce07da-114d-48e7-8802-066b2ab4c087	36	0.4%
Other values (3444)	9544	95.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2d213fa9-1951-4265-8725-5c0992b155c2	93	0.9%
b16f77bf-6a58-49b0-8b8f-da7c7058bfbf	47	0.5%
d453aad8-6c95-425a-8a63-f9fe012554f8	47	0.5%
e9e81cc8-0fef-4a75-a851-7ca7ddfd117b	41	0.4%
98f8b924-0f17-4285-898e-9b95b6de6162	40	0.4%
1b50bc7e-15c5-4ae7-822e-9b29988adf7b	38	0.4%
7d7c1e29-1a35-447c-b672-5899a55bc6f1	38	0.4%
44ebfb1a-9cfe-4791-8fc3-f8e5a0ff9b74	38	0.4%
2aef8afc-6d81-4c4b-b103-9bd4db52fe61	37	0.4%
86ce07da-114d-48e7-8802-066b2ab4c087	36	0.4%
Other values (3444)	9544	95.4%

Most occurring characters

Value	Count	Frequency (%)
-	39996	11.1%
4	28567	7.9%
9	22159	6.2%
8	21756	6.0%
b	21147	5.9%
a	20435	5.7%
1	19689	5.5%
6	19183	5.3%
2	19098	5.3%
d	19059	5.3%
Other values (7)	128875	35.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	204147	56.7%
Lowercase Letter	115821	32.2%
Dash Punctuation	39996	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	28567	14.0%
9	22159	10.9%
8	21756	10.7%
1	19689	9.6%
6	19183	9.4%
2	19098	9.4%
5	19014	9.3%
7	18398	9.0%
3	18171	8.9%
0	18112	8.9%

Lowercase Letter

Value	Count	Frequency (%)
b	21147	18.3%
a	20435	17.6%
d	19059	16.5%
f	18489	16.0%
e	18355	15.8%
c	18336	15.8%

Dash Punctuation

Value	Count	Frequency (%)
-	39996	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	244143	67.8%
Latin	115821	32.2%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	39996	16.4%
4	28567	11.7%
9	22159	9.1%
8	21756	8.9%
1	19689	8.1%
6	19183	7.9%
2	19098	7.8%
5	19014	7.8%
7	18398	7.5%
3	18171	7.4%

Latin

Value	Count	Frequency (%)
b	21147	18.3%
a	20435	17.6%
d	19059	16.5%
f	18489	16.0%
e	18355	15.8%
c	18336	15.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	359964	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	39996	11.1%
4	28567	7.9%
9	22159	6.2%
8	21756	6.0%
b	21147	5.9%
a	20435	5.7%
1	19689	5.5%
6	19183	5.3%
2	19098	5.3%
d	19059	5.3%
Other values (7)	128875	35.8%

total_mileage
Real number (ℝ)

MISSING SKEWED

Distinct	6330
Distinct (%)	76.1%
Missing	1684
Missing (%)	16.8%
Infinite	0
Infinite (%)	0.0%
Mean	6647965.3

Minimum	0
Maximum	4.2357077 × 10⁹
Zeros	83
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	248
Q1	2188.5
median	5647
Q3	10993
95-th percentile	18622.2
Maximum	4.2357077 × 10⁹
Range	4.2357077 × 10⁹
Interquartile range (IQR)	8804.5

Descriptive statistics

Standard deviation	1.4550904 × 10⁸
Coefficient of variation (CV)	21.887755
Kurtosis	602.62127
Mean	6647965.3
Median Absolute Deviation (MAD)	3995
Skewness	24.033411
Sum	5.5277832 × 10¹⁰
Variance	2.117288 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	83	0.8%
1	8	0.1%
2	8	0.1%
2112	8	0.1%
663	7	0.1%
63	7	0.1%
6	6	0.1%
937	6	0.1%
11	6	0.1%
2593	5	0.1%
Other values (6320)	8171	81.7%
(Missing)	1684	16.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	83	0.8%
1	8	0.1%
2	8	0.1%
3	4	< 0.1%
4	2	< 0.1%
5	1	< 0.1%
6	6	0.1%
9	1	< 0.1%
10	4	< 0.1%
11	6	0.1%

Value	Count	Frequency (%)
4235707659	1	< 0.1%
4145238046	1	< 0.1%
4011373570	1	< 0.1%
3967496428	1	< 0.1%
3818981767	1	< 0.1%
3634652942	2	< 0.1%
3461804109	1	< 0.1%
3428659541	1	< 0.1%
3379368544	1	< 0.1%
3125455142	1	< 0.1%

versions_mc_firmware
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	7
Distinct (%)	0.1%
Missing	2026
Missing (%)	20.3%
Memory size	78.2 KiB

DA210815.10	7892
000000.0	54
DA210727.9	16
DA210524.7	5
DA٢١٠٨١٥.10	3
Other values (2)	3

Length

Max length	11
Median length	11
Mean length	10.976922
Min length	8

Characters and Unicode

Total characters	87519
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	3 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	DA210815.10
2nd row	DA210815.10
3rd row	DA210815.10
4th row	DA210815.10
5th row	DA210815.10

Common Values

Value	Count	Frequency (%)
DA210815.10	7892	78.9%
000000.0	54	0.5%
DA210727.9	16	0.2%
DA210524.7	5	0.1%
DA٢١٠٨١٥.10	3	< 0.1%
DA220125.11	2	< 0.1%
DA081510.0	1	< 0.1%
(Missing)	2026	20.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
da210815.10	7892	99.0%
000000.0	54	0.7%
da210727.9	16	0.2%
da210524.7	5	0.1%
da٢١٠٨١٥.10	3	< 0.1%
da220125.11	2	< 0.1%
da081510.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	23708	27.1%
0	16191	18.5%
.	7973	9.1%
2	7940	9.1%
D	7919	9.0%
A	7919	9.0%
5	7900	9.0%
8	7893	9.0%
7	37	< 0.1%
9	16	< 0.1%
Other values (6)	23	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	63708	72.8%
Uppercase Letter	15838	18.1%
Other Punctuation	7973	9.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	23708	37.2%
0	16191	25.4%
2	7940	12.5%
5	7900	12.4%
8	7893	12.4%
7	37	0.1%
9	16	< 0.1%
١	6	< 0.1%
4	5	< 0.1%
٢	3	< 0.1%
Other values (3)	9	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
D	7919	50.0%
A	7919	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	7973	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	71663	81.9%
Latin	15838	18.1%
Arabic	18	< 0.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	23708	33.1%
0	16191	22.6%
.	7973	11.1%
2	7940	11.1%
5	7900	11.0%
8	7893	11.0%
7	37	0.1%
9	16	< 0.1%
4	5	< 0.1%

Arabic

Value	Count	Frequency (%)
١	6	33.3%
٢	3	16.7%
٠	3	16.7%
٨	3	16.7%
٥	3	16.7%

Latin

Value	Count	Frequency (%)
D	7919	50.0%
A	7919	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	87501	> 99.9%
Arabic	18	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	23708	27.1%
0	16191	18.5%
.	7973	9.1%
2	7940	9.1%
D	7919	9.1%
A	7919	9.1%
5	7900	9.0%
8	7893	9.0%
7	37	< 0.1%
9	16	< 0.1%

Arabic

Value	Count	Frequency (%)
١	6	33.3%
٢	3	16.7%
٠	3	16.7%
٨	3	16.7%
٥	3	16.7%

occurred_at_time
Categorical

HIGH CARDINALITY UNIFORM

Distinct	9718
Distinct (%)	97.2%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

2023-06-28 06:42:15	3
2023-07-12 18:47:18	3
2023-06-27 16:14:22	3
2022-08-17 09:21:58	3
2023-02-03 22:36:30	3
Other values (9713)	9984

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	189981
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9444 ?
Unique (%)	94.4%

Sample

1st row	2023-04-05 08:54:50
2nd row	2022-09-05 18:13:47
3rd row	2023-09-10 12:22:06
4th row	2022-09-14 07:50:05
5th row	2022-09-12 14:12:19

Common Values

Value	Count	Frequency (%)
2023-06-28 06:42:15	3	< 0.1%
2023-07-12 18:47:18	3	< 0.1%
2023-06-27 16:14:22	3	< 0.1%
2022-08-17 09:21:58	3	< 0.1%
2023-02-03 22:36:30	3	< 0.1%
2023-06-20 12:31:43	3	< 0.1%
2022-09-28 13:53:29	3	< 0.1%
2023-03-28 16:35:30	2	< 0.1%
2022-08-16 14:03:25	2	< 0.1%
2023-08-28 09:06:32	2	< 0.1%
Other values (9708)	9972	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2023-09-06	94	0.5%
2023-07-11	78	0.4%
2023-09-13	74	0.4%
2023-09-14	72	0.4%
2023-09-07	69	0.3%
2023-06-20	67	0.3%
2023-09-12	65	0.3%
2023-09-18	65	0.3%
2023-08-31	64	0.3%
2023-09-11	63	0.3%
Other values (9413)	19287	96.4%

Most occurring characters

Value	Count	Frequency (%)
2	34758	18.3%
0	31781	16.7%
1	20322	10.7%
-	19998	10.5%
:	19998	10.5%
3	14799	7.8%
	9999	5.3%
5	7983	4.2%
4	7420	3.9%
7	5872	3.1%
Other values (3)	17051	9.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	139986	73.7%
Dash Punctuation	19998	10.5%
Other Punctuation	19998	10.5%
Space Separator	9999	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	34758	24.8%
0	31781	22.7%
1	20322	14.5%
3	14799	10.6%
5	7983	5.7%
4	7420	5.3%
7	5872	4.2%
8	5810	4.2%
6	5702	4.1%
9	5539	4.0%

Dash Punctuation

Value	Count	Frequency (%)
-	19998	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	19998	100.0%

Space Separator

Value	Count	Frequency (%)
	9999	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	189981	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	34758	18.3%
0	31781	16.7%
1	20322	10.7%
-	19998	10.5%
:	19998	10.5%
3	14799	7.8%
	9999	5.3%
5	7983	4.2%
4	7420	3.9%
7	5872	3.1%
Other values (3)	17051	9.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	189981	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	34758	18.3%
0	31781	16.7%
1	20322	10.7%
-	19998	10.5%
:	19998	10.5%
3	14799	7.8%
	9999	5.3%
5	7983	4.2%
4	7420	3.9%
7	5872	3.1%
Other values (3)	17051	9.0%

app_version
Categorical

Distinct	107
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

2023.7.6	533
2023.8.16	471
2023.6.12	455
2023.4.21	451
2022.7.19	415
Other values (102)	7674

Length

Max length	28
Median length	9
Mean length	11.638064
Min length	3

Characters and Unicode

Total characters	116369
Distinct characters	23
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	0.1%

Sample

1st row	2023.03.24-3923-prod-release
2nd row	2022.8.26
3rd row	2023.9.4
4th row	2022.08.30-3095-prod-release
5th row	2022.8.29

Common Values

Value	Count	Frequency (%)
2023.7.6	533	5.3%
2023.8.16	471	4.7%
2023.6.12	455	4.6%
2023.4.21	451	4.5%
2022.7.19	415	4.2%
2022.8.26	307	3.1%
2023.9.4	303	3.0%
2023.3.28	285	2.9%
2023.5.15	285	2.9%
2023.1.11	284	2.8%
Other values (97)	6210	62.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2023.7.6	533	5.3%
2023.8.16	471	4.7%
2023.6.12	455	4.6%
2023.4.21	451	4.5%
2022.7.19	415	4.2%
2022.8.26	307	3.1%
2023.9.4	303	3.0%
2023.3.28	285	2.9%
2023.5.15	285	2.9%
2023.1.11	284	2.8%
Other values (97)	6210	62.1%

Most occurring characters

Value	Count	Frequency (%)
2	28319	24.3%
.	19990	17.2%
0	13343	11.5%
3	9230	7.9%
1	8634	7.4%
-	4313	3.7%
e	4309	3.7%
6	3467	3.0%
8	3068	2.6%
9	3050	2.6%
Other values (13)	18646	16.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	76245	65.5%
Other Punctuation	19990	17.2%
Lowercase Letter	15821	13.6%
Dash Punctuation	4313	3.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4309	27.2%
r	2874	18.2%
d	1443	9.1%
o	1439	9.1%
p	1439	9.1%
l	1435	9.1%
a	1435	9.1%
s	1435	9.1%
b	4	< 0.1%
u	4	< 0.1%

Decimal Number

Value	Count	Frequency (%)
2	28319	37.1%
0	13343	17.5%
3	9230	12.1%
1	8634	11.3%
6	3467	4.5%
8	3068	4.0%
9	3050	4.0%
7	2793	3.7%
4	2669	3.5%
5	1672	2.2%

Other Punctuation

Value	Count	Frequency (%)
.	19990	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4313	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	100548	86.4%
Latin	15821	13.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	28319	28.2%
.	19990	19.9%
0	13343	13.3%
3	9230	9.2%
1	8634	8.6%
-	4313	4.3%
6	3467	3.4%
8	3068	3.1%
9	3050	3.0%
7	2793	2.8%
Other values (2)	4341	4.3%

Latin

Value	Count	Frequency (%)
e	4309	27.2%
r	2874	18.2%
d	1443	9.1%
o	1439	9.1%
p	1439	9.1%
l	1435	9.1%
a	1435	9.1%
s	1435	9.1%
b	4	< 0.1%
u	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	116369	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	28319	24.3%
.	19990	17.2%
0	13343	11.5%
3	9230	7.9%
1	8634	7.4%
-	4313	3.7%
e	4309	3.7%
6	3467	3.0%
8	3068	2.6%
9	3050	2.6%
Other values (13)	18646	16.0%

assist_level
Real number (ℝ)

MISSING SKEWED ZEROS

Distinct	7
Distinct (%)	0.1%
Missing	1798
Missing (%)	18.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8598951

Minimum	0
Maximum	205
Zeros	475
Zeros (%)	4.8%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	2
95-th percentile	2
Maximum	205
Range	205
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	7.4874694
Coefficient of variation (CV)	4.0257481
Kurtosis	599.89668
Mean	1.8598951
Median Absolute Deviation (MAD)	0
Skewness	23.947944
Sum	15253
Variance	56.062198
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	4835	48.4%
1	2874	28.7%
0	475	4.8%
112	8	0.1%
205	6	0.1%
191	2	< 0.1%
201	1	< 0.1%
(Missing)	1798	18.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	475	4.8%
1	2874	28.7%
2	4835	48.4%
112	8	0.1%
191	2	< 0.1%
201	1	< 0.1%
205	6	0.1%

Value	Count	Frequency (%)
205	6	0.1%
201	1	< 0.1%
191	2	< 0.1%
112	8	0.1%
2	4835	48.4%
1	2874	28.7%
0	475	4.8%

battery_cells
Categorical

HIGH CARDINALITY MISSING

Distinct	782
Distinct (%)	54.8%
Missing	8573
Missing (%)	85.7%
Memory size	78.2 KiB

[null,null,null,null,null,null,null,null,null,null]	620
[4021,4021,4023,4019,4022,4026,4024,3973,4007,4006]	2
[3933,3925,3942,3927,3933,3944,3936,3964,3961,3964]	2
[3864,3860,3870,3865,3881,3888,3886,3812,3823,3835]	2
[4107,4110,4106,4102,4106,4121,4121,4121,4121,4124]	2
Other values (777)	798

Length

Max length	51
Median length	51
Mean length	50.957924
Min length	21

Characters and Unicode

Total characters	72666
Distinct characters	16
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	756 ?
Unique (%)	53.0%

Sample

1st row	[null,null,null,null,null,null,null,null,null,null]
2nd row	[3997,3997,4001,3994,4000,4013,4014,4015,4009,4012]
3rd row	[4081,4081,4082,4083,4081,4085,4083,4083,4085,4083]
4th row	[3913,3911,3911,3911,3911,3923,3921,3914,3923,3922]
5th row	[null,null,null,null,null,null,null,null,null,null]

Common Values

Value	Count	Frequency (%)
[null,null,null,null,null,null,null,null,null,null]	620	6.2%
[4021,4021,4023,4019,4022,4026,4024,3973,4007,4006]	2	< 0.1%
[3933,3925,3942,3927,3933,3944,3936,3964,3961,3964]	2	< 0.1%
[3864,3860,3870,3865,3881,3888,3886,3812,3823,3835]	2	< 0.1%
[4107,4110,4106,4102,4106,4121,4121,4121,4121,4124]	2	< 0.1%
[0,0,0,0,0,0,0,0,0,0]	2	< 0.1%
[3900,3902,3900,3902,3903,3918,3915,3744,3755,3756]	2	< 0.1%
[3814,3816,3811,3814,3815,3824,3823,3821,3820,3820]	2	< 0.1%
[4004,4005,4004,4000,4008,4016,4015,4017,4016,4017]	2	< 0.1%
[4015,4018,4013,4013,4012,4020,4022,4022,4022,4022]	2	< 0.1%
Other values (772)	788	7.9%
(Missing)	8573	85.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
null,null,null,null,null,null,null,null,null,null	620	43.5%
4071,4068,4066,4069,4069,4072,4071,4070,4068,4071	2	0.1%
3972,3954,3972,3957,3961,3971,3953,4004,3994,3994	2	0.1%
3593,4073,4075,4072,4074,4076,4080,4079,4079,4080	2	0.1%
3897,3886,3906,3893,3899,3909,3900,3948,3947,3956	2	0.1%
3960,3956,3956,3959,3957,3973,3969,3966,3966,3967	2	0.1%
4011,4014,4019,4019,4017,4019,4014,4023,4012,4011	2	0.1%
3721,3711,3736,3714,3719,3733,3716,3724,3718,3727	2	0.1%
3695,3692,3692,3694,3696,3706,3706,3476,3533,3538	2	0.1%
4128,4120,4120,4129,4125,4147,4146,4142,4140,4145	2	0.1%
Other values (772)	788	55.3%

Most occurring characters

Value	Count	Frequency (%)
,	12834	17.7%
l	12508	17.2%
3	6700	9.2%
n	6254	8.6%
u	6254	8.6%
4	4892	6.7%
0	3580	4.9%
8	2904	4.0%
9	2824	3.9%
7	2470	3.4%
Other values (6)	11446	15.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	31964	44.0%
Lowercase Letter	25016	34.4%
Other Punctuation	12834	17.7%
Open Punctuation	1426	2.0%
Close Punctuation	1426	2.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	6700	21.0%
4	4892	15.3%
0	3580	11.2%
8	2904	9.1%
9	2824	8.8%
7	2470	7.7%
1	2460	7.7%
6	2357	7.4%
5	2168	6.8%
2	1609	5.0%

Lowercase Letter

Value	Count	Frequency (%)
l	12508	50.0%
n	6254	25.0%
u	6254	25.0%

Other Punctuation

Value	Count	Frequency (%)
,	12834	100.0%

Open Punctuation

Value	Count	Frequency (%)
[	1426	100.0%

Close Punctuation

Value	Count	Frequency (%)
]	1426	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	47650	65.6%
Latin	25016	34.4%

Most frequent character per script

Common

Value	Count	Frequency (%)
,	12834	26.9%
3	6700	14.1%
4	4892	10.3%
0	3580	7.5%
8	2904	6.1%
9	2824	5.9%
7	2470	5.2%
1	2460	5.2%
6	2357	4.9%
5	2168	4.5%
Other values (3)	4461	9.4%

Latin

Value	Count	Frequency (%)
l	12508	50.0%
n	6254	25.0%
u	6254	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	72666	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
,	12834	17.7%
l	12508	17.2%
3	6700	9.2%
n	6254	8.6%
u	6254	8.6%
4	4892	6.7%
0	3580	4.9%
8	2904	4.0%
9	2824	3.9%
7	2470	3.4%
Other values (6)	11446	15.8%

battery_error_state
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	15
Distinct (%)	0.2%
Missing	76
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	9601744.3

Minimum	0
Maximum	2.1810381 × 10⁹
Zeros	9872
Zeros (%)	98.7%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	2.1810381 × 10⁹
Range	2.1810381 × 10⁹
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.4283984 × 10⁸
Coefficient of variation (CV)	14.876447
Kurtosis	220.36174
Mean	9601744.3
Median Absolute Deviation (MAD)	0
Skewness	14.906269
Sum	9.5278109 × 10¹⁰
Variance	2.040322 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
0	9872	98.7%
2147615233	10	0.1%
2147487776	10	0.1%
2147483649	10	0.1%
2147485728	5	0.1%
205290152	3	< 0.1%
2164260864	2	< 0.1%
33556784	2	< 0.1%
2148663808	2	< 0.1%
16779536	2	< 0.1%
Other values (5)	5	0.1%
(Missing)	76	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9872	98.7%
16779536	2	< 0.1%
33556784	2	< 0.1%
205290152	3	< 0.1%
2147483649	10	0.1%
2147485728	5	0.1%
2147487776	10	0.1%
2147489824	1	< 0.1%
2147614720	1	< 0.1%
2147614722	1	< 0.1%

Value	Count	Frequency (%)
2181038080	1	< 0.1%
2164260864	2	< 0.1%
2148663810	1	< 0.1%
2148663808	2	< 0.1%
2147615233	10	0.1%
2147614722	1	< 0.1%
2147614720	1	< 0.1%
2147489824	1	< 0.1%
2147487776	10	0.1%
2147485728	5	0.1%

battery_serial_number
Categorical

HIGH CARDINALITY MISSING

Distinct	4408
Distinct (%)	54.6%
Missing	1925
Missing (%)	19.3%
Memory size	78.2 KiB

2VHT02401P02-P4BR522	140
BAT_SN	125
HT1002MA121520110	33
HT1002MA121520478	30
3256485430323430315030322d50344252353232	27
Other values (4403)	7719

Length

Max length	512
Median length	17
Mean length	56.547684
Min length	6

Characters and Unicode

Total characters	456566
Distinct characters	45
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3000 ?
Unique (%)	37.2%

Sample

1st row	HT1002MA121521183
2nd row	HT1002MA121251821
3rd row	4854313030324d41313231353231373236000000
4th row	HT1002MA122120371HT1002MA122120371HT1002MA122120371HT1002MA122120371HT1002MA122120371
5th row	HT1002MA121340143

Common Values

Value	Count	Frequency (%)
2VHT02401P02-P4BR522	140	1.4%
BAT_SN	125	1.3%
HT1002MA121520110	33	0.3%
HT1002MA121520478	30	0.3%
3256485430323430315030322d50344252353232	27	0.3%
HT1002MA122080723	26	0.3%
HT1002MA121520980	24	0.2%
HT1002MA122080276	20	0.2%
HT1002MA121521549	20	0.2%
HT1002MA121402126	18	0.2%
Other values (4398)	7611	76.1%
(Missing)	1925	19.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ht1002ma123240225	166	1.8%
123	156	1.7%
2vht02401p02-p4br522	140	1.5%
bat_sn	125	1.3%
12398122long	74	0.8%
123ht1002ma32233064long	59	0.6%
ht1002ma323310199	50	0.5%
123ht1002ma32233096long	40	0.4%
ht1002ma322391121	39	0.4%
ht1002ma121520110	33	0.4%
Other values (4381)	8378	90.5%

Most occurring characters

Value	Count	Frequency (%)
2	89442	19.6%
0	87109	19.1%
1	74164	16.2%
3	26261	5.8%
T	24962	5.5%
H	24803	5.4%
A	24758	5.4%
M	24560	5.4%
4	21645	4.7%
5	14242	3.1%
Other values (35)	44620	9.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	350215	76.7%
Uppercase Letter	103239	22.6%
Control	1265	0.3%
Lowercase Letter	801	0.2%
Space Separator	641	0.1%
Dash Punctuation	239	0.1%
Connector Punctuation	161	< 0.1%
Other Punctuation	5	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	24962	24.2%
H	24803	24.0%
A	24758	24.0%
M	24560	23.8%
N	795	0.8%
G	640	0.6%
L	636	0.6%
O	636	0.6%
P	478	0.5%
B	408	0.4%
Other values (7)	563	0.5%

Lowercase Letter

Value	Count	Frequency (%)
d	707	88.3%
e	23	2.9%
i	12	1.5%
t	12	1.5%
c	6	0.7%
v	6	0.7%
n	6	0.7%
g	6	0.7%
a	6	0.7%
r	6	0.7%
Other values (2)	11	1.4%

Decimal Number

Value	Count	Frequency (%)
2	89442	25.5%
0	87109	24.9%
1	74164	21.2%
3	26261	7.5%
4	21645	6.2%
5	14242	4.1%
6	11662	3.3%
8	11269	3.2%
9	7272	2.1%
7	7149	2.0%

Control

Value	Count	Frequency (%)
	633	50.0%
	632	50.0%

Space Separator

Value	Count	Frequency (%)
	641	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	239	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	161	100.0%

Other Punctuation

Value	Count	Frequency (%)
¡	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	352526	77.2%
Latin	104040	22.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	24962	24.0%
H	24803	23.8%
A	24758	23.8%
M	24560	23.6%
N	795	0.8%
d	707	0.7%
G	640	0.6%
L	636	0.6%
O	636	0.6%
P	478	0.5%
Other values (19)	1065	1.0%

Common

Value	Count	Frequency (%)
2	89442	25.4%
0	87109	24.7%
1	74164	21.0%
3	26261	7.4%
4	21645	6.1%
5	14242	4.0%
6	11662	3.3%
8	11269	3.2%
9	7272	2.1%
7	7149	2.0%
Other values (6)	2311	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	456561	> 99.9%
None	5	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	89442	19.6%
0	87109	19.1%
1	74164	16.2%
3	26261	5.8%
T	24962	5.5%
H	24803	5.4%
A	24758	5.4%
M	24560	5.4%
4	21645	4.7%
5	14242	3.1%
Other values (34)	44615	9.8%

None

Value	Count	Frequency (%)
¡	5	100.0%

battery_state_battery_soc
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	101
Distinct (%)	1.2%
Missing	1907
Missing (%)	19.1%
Infinite	0
Infinite (%)	0.0%
Mean	67.747158

Minimum	0
Maximum	100
Zeros	13
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	26
Q1	52
median	71
Q3	86
95-th percentile	99
Maximum	100
Range	100
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	22.789468
Coefficient of variation (CV)	0.33639003
Kurtosis	-0.46337
Mean	67.747158
Median Absolute Deviation (MAD)	17
Skewness	-0.55026616
Sum	548210
Variance	519.35987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	295	3.0%
99	199	2.0%
86	164	1.6%
98	159	1.6%
82	159	1.6%
87	154	1.5%
88	151	1.5%
85	150	1.5%
81	149	1.5%
80	144	1.4%
Other values (91)	6368	63.7%
(Missing)	1907	19.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13	0.1%
1	2	< 0.1%
2	3	< 0.1%
3	3	< 0.1%
4	7	0.1%
5	9	0.1%
6	6	0.1%
7	6	0.1%
8	9	0.1%
9	12	0.1%

Value	Count	Frequency (%)
100	295	3.0%
99	199	2.0%
98	159	1.6%
97	129	1.3%
96	90	0.9%
95	128	1.3%
94	103	1.0%
93	127	1.3%
92	96	1.0%
91	114	1.1%

battery_state_battery_soh
Real number (ℝ)

Distinct	25
Distinct (%)	0.3%
Missing	1907
Missing (%)	19.1%
Infinite	0
Infinite (%)	0.0%
Mean	97.368018

Minimum	0
Maximum	100
Zeros	14
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	93
Q1	97
median	98
Q3	99
95-th percentile	99
Maximum	100
Range	100
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	4.6096689
Coefficient of variation (CV)	0.047342742
Kurtosis	342.50145
Mean	97.368018
Median Absolute Deviation (MAD)	1
Skewness	-16.583122
Sum	787902
Variance	21.249047
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
99	3110	31.1%
98	1919	19.2%
97	1044	10.4%
96	676	6.8%
95	368	3.7%
100	308	3.1%
94	232	2.3%
93	141	1.4%
92	87	0.9%
91	56	0.6%
Other values (15)	151	1.5%
(Missing)	1907	19.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14	0.1%
72	2	< 0.1%
78	1	< 0.1%
79	2	< 0.1%
80	2	< 0.1%
81	1	< 0.1%
82	4	< 0.1%
83	1	< 0.1%
84	2	< 0.1%
85	4	< 0.1%

Value	Count	Frequency (%)
100	308	3.1%
99	3110	31.1%
98	1919	19.2%
97	1044	10.4%
96	676	6.8%
95	368	3.7%
94	232	2.3%
93	141	1.4%
92	87	0.9%
91	56	0.6%

battery_state_cell_temp_1
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	39
Distinct (%)	2.8%
Missing	8595
Missing (%)	86.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.729345

Minimum	0
Maximum	96
Zeros	591
Zeros (%)	5.9%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	20
Q3	26
95-th percentile	33
Maximum	96
Range	96
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	13.416598
Coefficient of variation (CV)	0.9108754
Kurtosis	-0.7973934
Mean	14.729345
Median Absolute Deviation (MAD)	11
Skewness	0.11386607
Sum	20680
Variance	180.0051
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
0	591	5.9%
26	72	0.7%
27	65	0.7%
25	61	0.6%
29	58	0.6%
23	56	0.6%
21	56	0.6%
24	49	0.5%
28	49	0.5%
22	45	0.5%
Other values (29)	302	3.0%
(Missing)	8595	86.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	591	5.9%
1	2	< 0.1%
2	1	< 0.1%
6	1	< 0.1%
9	1	< 0.1%
10	6	0.1%
11	3	< 0.1%
12	5	0.1%
13	7	0.1%
14	4	< 0.1%

Value	Count	Frequency (%)
96	1	< 0.1%
43	1	< 0.1%
42	1	< 0.1%
40	1	< 0.1%
39	2	< 0.1%
38	3	< 0.1%
37	2	< 0.1%
36	11	0.1%
35	14	0.1%
34	15	0.2%

battery_state_cell_temp_2
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	38
Distinct (%)	2.7%
Missing	8595
Missing (%)	86.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.598291

Minimum	0
Maximum	90
Zeros	592
Zeros (%)	5.9%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	20
Q3	26
95-th percentile	32
Maximum	90
Range	90
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	13.287689
Coefficient of variation (CV)	0.91022225
Kurtosis	-1.014763
Mean	14.598291
Median Absolute Deviation (MAD)	11
Skewness	0.0852262
Sum	20496
Variance	176.56268
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
0	592	5.9%
26	69	0.7%
25	68	0.7%
27	63	0.6%
23	58	0.6%
22	54	0.5%
28	53	0.5%
29	49	0.5%
31	47	0.5%
21	46	0.5%
Other values (28)	305	3.1%
(Missing)	8595	86.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	592	5.9%
1	2	< 0.1%
2	1	< 0.1%
6	1	< 0.1%
9	2	< 0.1%
10	5	0.1%
11	3	< 0.1%
12	4	< 0.1%
13	8	0.1%
14	4	< 0.1%

Value	Count	Frequency (%)
90	1	< 0.1%
42	1	< 0.1%
41	1	< 0.1%
40	1	< 0.1%
39	2	< 0.1%
37	6	0.1%
36	8	0.1%
35	10	0.1%
34	15	0.2%
33	25	0.3%

battery_state_chg_temp
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	40
Distinct (%)	2.8%
Missing	8595
Missing (%)	86.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.878205

Minimum	0
Maximum	255
Zeros	594
Zeros (%)	5.9%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	20
Q3	28
95-th percentile	36
Maximum	255
Range	255
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	15.726824
Coefficient of variation (CV)	0.99046608
Kurtosis	36.205172
Mean	15.878205
Median Absolute Deviation (MAD)	15
Skewness	2.5048222
Sum	22293
Variance	247.33298
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
0	594	5.9%
25	67	0.7%
28	54	0.5%
31	49	0.5%
27	45	0.5%
29	44	0.4%
22	44	0.4%
30	42	0.4%
26	41	0.4%
33	38	0.4%
Other values (30)	386	3.9%
(Missing)	8595	86.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	594	5.9%
6	1	< 0.1%
8	3	< 0.1%
9	1	< 0.1%
10	3	< 0.1%
11	7	0.1%
12	4	< 0.1%
13	2	< 0.1%
14	10	0.1%
15	6	0.1%

Value	Count	Frequency (%)
255	1	< 0.1%
48	1	< 0.1%
47	1	< 0.1%
43	3	< 0.1%
41	6	0.1%
40	11	0.1%
39	9	0.1%
38	15	0.2%
37	19	0.2%
36	21	0.2%

battery_state_dsg_temp
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	40
Distinct (%)	2.8%
Missing	8595
Missing (%)	86.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.881766

Minimum	0
Maximum	255
Zeros	594
Zeros (%)	5.9%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	20
Q3	28
95-th percentile	36
Maximum	255
Range	255
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	15.72855
Coefficient of variation (CV)	0.9903527
Kurtosis	36.185787
Mean	15.881766
Median Absolute Deviation (MAD)	15
Skewness	2.5034773
Sum	22298
Variance	247.38729
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
0	594	5.9%
25	67	0.7%
28	54	0.5%
31	49	0.5%
27	45	0.5%
29	44	0.4%
22	44	0.4%
24	42	0.4%
30	42	0.4%
26	41	0.4%
Other values (30)	382	3.8%
(Missing)	8595	86.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	594	5.9%
6	1	< 0.1%
8	3	< 0.1%
9	1	< 0.1%
10	3	< 0.1%
11	7	0.1%
12	4	< 0.1%
13	2	< 0.1%
14	10	0.1%
15	6	0.1%

Value	Count	Frequency (%)
255	1	< 0.1%
48	1	< 0.1%
47	1	< 0.1%
43	3	< 0.1%
41	6	0.1%
40	11	0.1%
39	9	0.1%
38	15	0.2%
37	19	0.2%
36	21	0.2%

battery_state_full_capacity
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	105
Distinct (%)	7.5%
Missing	8595
Missing (%)	86.0%
Infinite	0
Infinite (%)	0.0%
Mean	5399.4993

Minimum	0
Maximum	9506
Zeros	591
Zeros (%)	5.9%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	9134
Q3	9417
95-th percentile	9491
Maximum	9506
Range	9506
Interquartile range (IQR)	9417

Descriptive statistics

Standard deviation	4608.0912
Coefficient of variation (CV)	0.85342936
Kurtosis	-1.8976715
Mean	5399.4993
Median Absolute Deviation (MAD)	357
Skewness	-0.31703031
Sum	7580897
Variance	21234505
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	591	5.9%
9484	53	0.5%
9499	41	0.4%
9476	38	0.4%
9468	31	0.3%
9491	31	0.3%
9506	27	0.3%
9438	25	0.3%
9461	24	0.2%
9453	24	0.2%
Other values (95)	519	5.2%
(Missing)	8595	86.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	591	5.9%
8176	1	< 0.1%
8191	1	< 0.1%
8252	1	< 0.1%
8366	1	< 0.1%
8472	3	< 0.1%
8488	1	< 0.1%
8526	1	< 0.1%
8594	2	< 0.1%
8602	2	< 0.1%

Value	Count	Frequency (%)
9506	27	0.3%
9499	41	0.4%
9491	31	0.3%
9484	53	0.5%
9476	38	0.4%
9468	31	0.3%
9461	24	0.2%
9453	24	0.2%
9446	22	0.2%
9438	25	0.3%

battery_state_pack_voltage
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	5450
Distinct (%)	67.4%
Missing	1907
Missing (%)	19.1%
Infinite	0
Infinite (%)	0.0%
Mean	-14984.501

Minimum	-32766
Maximum	41878
Zeros	13
Zeros (%)	0.1%
Negative	6581
Negative (%)	65.8%
Memory size	78.2 KiB

Quantile statistics

Minimum	-32766
5-th percentile	-30447.45
Q1	-28052
median	-26050.5
Q3	-24538
95-th percentile	40512
Maximum	41878
Range	74644
Interquartile range (IQR)	3514

Descriptive statistics

Standard deviation	25319.913
Coefficient of variation (CV)	-1.6897402
Kurtosis	0.70536722
Mean	-14984.501
Median Absolute Deviation (MAD)	1792.5
Skewness	1.6250088
Sum	-1.2125458 × 10⁸
Variance	6.4109802 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4200	38	0.4%
0	13	0.1%
-24821	7	0.1%
-24790	6	0.1%
-24777	6	0.1%
-24898	6	0.1%
-28275	6	0.1%
-27111	6	0.1%
-24804	6	0.1%
-24822	6	0.1%
Other values (5440)	7992	79.9%
(Missing)	1907	19.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-32766	1	< 0.1%
-32730	1	< 0.1%
-32725	1	< 0.1%
-32610	1	< 0.1%
-32560	1	< 0.1%
-32550	1	< 0.1%
-32549	1	< 0.1%
-32530	1	< 0.1%
-32514	1	< 0.1%
-32507	1	< 0.1%

Value	Count	Frequency (%)
41878	1	< 0.1%
41865	1	< 0.1%
41849	1	< 0.1%
41824	1	< 0.1%
41818	1	< 0.1%
41816	1	< 0.1%
41815	1	< 0.1%
41814	1	< 0.1%
41812	1	< 0.1%
41798	1	< 0.1%

battery_state_pre_start_temp
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	40
Distinct (%)	2.8%
Missing	8595
Missing (%)	86.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.885328

Minimum	0
Maximum	255
Zeros	594
Zeros (%)	5.9%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	20
Q3	28
95-th percentile	36
Maximum	255
Range	255
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	15.730502
Coefficient of variation (CV)	0.99025358
Kurtosis	36.164213
Mean	15.885328
Median Absolute Deviation (MAD)	15
Skewness	2.5020697
Sum	22303
Variance	247.44871
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
0	594	5.9%
25	72	0.7%
28	54	0.5%
31	49	0.5%
27	45	0.5%
29	44	0.4%
22	44	0.4%
30	42	0.4%
26	41	0.4%
33	38	0.4%
Other values (30)	381	3.8%
(Missing)	8595	86.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	594	5.9%
6	1	< 0.1%
8	3	< 0.1%
9	1	< 0.1%
10	3	< 0.1%
11	7	0.1%
12	4	< 0.1%
13	2	< 0.1%
14	10	0.1%
15	6	0.1%

Value	Count	Frequency (%)
255	1	< 0.1%
48	1	< 0.1%
47	1	< 0.1%
43	3	< 0.1%
41	6	0.1%
40	11	0.1%
39	9	0.1%
38	15	0.2%
37	19	0.2%
36	21	0.2%

battery_state_real_time_current
Real number (ℝ)

Distinct	1696
Distinct (%)	21.0%
Missing	1907
Missing (%)	19.1%
Infinite	0
Infinite (%)	0.0%
Mean	-1952.1338

Minimum	-18610
Maximum	9252
Zeros	13
Zeros (%)	0.1%
Negative	8072
Negative (%)	80.7%
Memory size	78.2 KiB

Quantile statistics

Minimum	-18610
5-th percentile	-11700.85
Q1	-1469.75
median	-74
Q3	-60
95-th percentile	-27
Maximum	9252
Range	27862
Interquartile range (IQR)	1409.75

Descriptive statistics

Standard deviation	3937.3694
Coefficient of variation (CV)	-2.0169567
Kurtosis	3.7772679
Mean	-1952.1338
Median Absolute Deviation (MAD)	19
Skewness	-2.1826016
Sum	-15796667
Variance	15502878
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-63	664	6.6%
-60	614	6.1%
-65	549	5.5%
-57	406	4.1%
-68	393	3.9%
-71	346	3.5%
-74	241	2.4%
-76	167	1.7%
-93	154	1.5%
-96	153	1.5%
Other values (1686)	4405	44.1%
(Missing)	1907	19.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-18610	1	< 0.1%
-17616	1	< 0.1%
-17528	1	< 0.1%
-16907	1	< 0.1%
-16693	1	< 0.1%
-16487	1	< 0.1%
-16473	1	< 0.1%
-16341	1	< 0.1%
-16240	1	< 0.1%
-16234	1	< 0.1%

Value	Count	Frequency (%)
9252	1	< 0.1%
5654	1	< 0.1%
74	1	< 0.1%
13	1	< 0.1%
2	3	< 0.1%
0	13	0.1%
-2	1	< 0.1%
-5	1	< 0.1%
-8	1	< 0.1%
-9	1	< 0.1%

battery_state_remaining_capacity
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	734
Distinct (%)	52.3%
Missing	8595
Missing (%)	86.0%
Infinite	0
Infinite (%)	0.0%
Mean	3817.8611

Minimum	0
Maximum	9498
Zeros	591
Zeros (%)	5.9%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3897
Q3	7315.25
95-th percentile	9128.7
Maximum	9498
Range	9498
Interquartile range (IQR)	7315.25

Descriptive statistics

Standard deviation	3624.0034
Coefficient of variation (CV)	0.94922347
Kurtosis	-1.6721612
Mean	3817.8611
Median Absolute Deviation (MAD)	3897
Skewness	0.12921647
Sum	5360277
Variance	13133401
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	591	5.9%
8250	5	0.1%
6450	4	< 0.1%
8567	4	< 0.1%
9445	4	< 0.1%
7685	3	< 0.1%
7287	3	< 0.1%
9162	3	< 0.1%
9005	2	< 0.1%
4731	2	< 0.1%
Other values (724)	783	7.8%
(Missing)	8595	86.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	591	5.9%
164	1	< 0.1%
404	1	< 0.1%
507	1	< 0.1%
646	1	< 0.1%
943	1	< 0.1%
976	1	< 0.1%
991	1	< 0.1%
1066	1	< 0.1%
1150	1	< 0.1%

Value	Count	Frequency (%)
9498	1	< 0.1%
9488	1	< 0.1%
9483	2	< 0.1%
9467	1	< 0.1%
9445	4	< 0.1%
9441	1	< 0.1%
9437	2	< 0.1%
9434	1	< 0.1%
9429	1	< 0.1%
9425	1	< 0.1%

dance_area
Categorical

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

PARIS	5073
BERLIN	2821
HAMBURG	1378
MUNICH	392
VIENNA	331

Length

Max length	11
Median length	5
Mean length	5.6324632
Min length	5

Characters and Unicode

Total characters	56319
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PARIS
2nd row	PARIS
3rd row	BERLIN
4th row	BERLIN
5th row	HAMBURG

Common Values

Value	Count	Frequency (%)
PARIS	5073	50.7%
BERLIN	2821	28.2%
HAMBURG	1378	13.8%
MUNICH	392	3.9%
VIENNA	331	3.3%
UNALLOCATED	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
paris	5073	50.7%
berlin	2821	28.2%
hamburg	1378	13.8%
munich	392	3.9%
vienna	331	3.3%
unallocated	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
R	9272	16.5%
I	8617	15.3%
A	6790	12.1%
P	5073	9.0%
S	5073	9.0%
B	4199	7.5%
N	3879	6.9%
E	3156	5.6%
L	2829	5.0%
U	1774	3.1%
Other values (8)	5657	10.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	56319	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	9272	16.5%
I	8617	15.3%
A	6790	12.1%
P	5073	9.0%
S	5073	9.0%
B	4199	7.5%
N	3879	6.9%
E	3156	5.6%
L	2829	5.0%
U	1774	3.1%
Other values (8)	5657	10.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	56319	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	9272	16.5%
I	8617	15.3%
A	6790	12.1%
P	5073	9.0%
S	5073	9.0%
B	4199	7.5%
N	3879	6.9%
E	3156	5.6%
L	2829	5.0%
U	1774	3.1%
Other values (8)	5657	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	56319	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	9272	16.5%
I	8617	15.3%
A	6790	12.1%
P	5073	9.0%
S	5073	9.0%
B	4199	7.5%
N	3879	6.9%
E	3156	5.6%
L	2829	5.0%
U	1774	3.1%
Other values (8)	5657	10.0%

event
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Vehicle Connected	9999

Length

Max length	17
Median length	17
Mean length	17
Min length	17

Characters and Unicode

Total characters	169983
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Vehicle Connected
2nd row	Vehicle Connected
3rd row	Vehicle Connected
4th row	Vehicle Connected
5th row	Vehicle Connected

Common Values

Value	Count	Frequency (%)
Vehicle Connected	9999	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
vehicle	9999	50.0%
connected	9999	50.0%

Most occurring characters

Value	Count	Frequency (%)
e	39996	23.5%
c	19998	11.8%
n	19998	11.8%
V	9999	5.9%
h	9999	5.9%
i	9999	5.9%
l	9999	5.9%
	9999	5.9%
C	9999	5.9%
o	9999	5.9%
Other values (2)	19998	11.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	139986	82.4%
Uppercase Letter	19998	11.8%
Space Separator	9999	5.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	39996	28.6%
c	19998	14.3%
n	19998	14.3%
h	9999	7.1%
i	9999	7.1%
l	9999	7.1%
o	9999	7.1%
t	9999	7.1%
d	9999	7.1%

Uppercase Letter

Value	Count	Frequency (%)
V	9999	50.0%
C	9999	50.0%

Space Separator

Value	Count	Frequency (%)
	9999	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	159984	94.1%
Common	9999	5.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	39996	25.0%
c	19998	12.5%
n	19998	12.5%
V	9999	6.2%
h	9999	6.2%
i	9999	6.2%
l	9999	6.2%
C	9999	6.2%
o	9999	6.2%
t	9999	6.2%

Common

Value	Count	Frequency (%)
	9999	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	169983	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	39996	23.5%
c	19998	11.8%
n	19998	11.8%
V	9999	5.9%
h	9999	5.9%
i	9999	5.9%
l	9999	5.9%
	9999	5.9%
C	9999	5.9%
o	9999	5.9%
Other values (2)	19998	11.8%

hmi_serial_number
Categorical

HIGH CARDINALITY MISSING

Distinct	3589
Distinct (%)	39.7%
Missing	962
Missing (%)	9.6%
Memory size	78.2 KiB

E96F7C	36
F1F5B5	35
1C25B6	35
CA24C6	31
EF1522	30
Other values (3584)	8870

Length

Max length	32
Median length	6
Mean length	6.9864999
Min length	6

Characters and Unicode

Total characters	63137
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1673 ?
Unique (%)	18.5%

Sample

1st row	60968A
2nd row	2C139F
3rd row	73D58B
4th row	22491134
5th row	89F0D3

Common Values

Value	Count	Frequency (%)
E96F7C	36	0.4%
F1F5B5	35	0.4%
1C25B6	35	0.4%
CA24C6	31	0.3%
EF1522	30	0.3%
8433D3	27	0.3%
BC86A0	26	0.3%
A3A8CB	25	0.3%
5B706B	24	0.2%
4AAFEB	23	0.2%
Other values (3579)	8745	87.5%
(Missing)	962	9.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
e96f7c	36	0.4%
1c25b6	35	0.4%
f1f5b5	35	0.4%
ca24c6	31	0.3%
ef1522	30	0.3%
8433d3	27	0.3%
bc86a0	26	0.3%
a3a8cb	25	0.3%
5b706b	24	0.3%
4aafeb	23	0.3%
Other values (3579)	8745	96.8%

Most occurring characters

Value	Count	Frequency (%)
2	8218	13.0%
3	6628	10.5%
4	5974	9.5%
1	5295	8.4%
0	5037	8.0%
5	4379	6.9%
9	4139	6.6%
6	3450	5.5%
7	3206	5.1%
8	2924	4.6%
Other values (8)	13887	22.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	49250	78.0%
Uppercase Letter	13883	22.0%
Lowercase Letter	4	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	8218	16.7%
3	6628	13.5%
4	5974	12.1%
1	5295	10.8%
0	5037	10.2%
5	4379	8.9%
9	4139	8.4%
6	3450	7.0%
7	3206	6.5%
8	2924	5.9%

Uppercase Letter

Value	Count	Frequency (%)
B	2531	18.2%
C	2310	16.6%
F	2283	16.4%
E	2272	16.4%
D	2239	16.1%
A	2239	16.1%
N	9	0.1%

Lowercase Letter

Value	Count	Frequency (%)
e	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	49250	78.0%
Latin	13887	22.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	8218	16.7%
3	6628	13.5%
4	5974	12.1%
1	5295	10.8%
0	5037	10.2%
5	4379	8.9%
9	4139	8.4%
6	3450	7.0%
7	3206	6.5%
8	2924	5.9%

Latin

Value	Count	Frequency (%)
B	2531	18.2%
C	2310	16.6%
F	2283	16.4%
E	2272	16.4%
D	2239	16.1%
A	2239	16.1%
N	9	0.1%
e	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	63137	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	8218	13.0%
3	6628	10.5%
4	5974	9.5%
1	5295	8.4%
0	5037	8.0%
5	4379	6.9%
9	4139	6.6%
6	3450	5.5%
7	3206	5.1%
8	2924	4.6%
Other values (8)	13887	22.0%

os_name
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

iOS	8559
Android	1439
iPadOS	1

Length

Max length	7
Median length	3
Mean length	3.5759576
Min length	3

Characters and Unicode

Total characters	35756
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Android
2nd row	iOS
3rd row	iOS
4th row	Android
5th row	iOS

Common Values

Value	Count	Frequency (%)
iOS	8559	85.6%
Android	1439	14.4%
iPadOS	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ios	8559	85.6%
android	1439	14.4%
ipados	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
i	9999	28.0%
O	8560	23.9%
S	8560	23.9%
d	2879	8.1%
A	1439	4.0%
n	1439	4.0%
r	1439	4.0%
o	1439	4.0%
P	1	< 0.1%
a	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	18560	51.9%
Lowercase Letter	17196	48.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	9999	58.1%
d	2879	16.7%
n	1439	8.4%
r	1439	8.4%
o	1439	8.4%
a	1	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
O	8560	46.1%
S	8560	46.1%
A	1439	7.8%
P	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35756	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	9999	28.0%
O	8560	23.9%
S	8560	23.9%
d	2879	8.1%
A	1439	4.0%
n	1439	4.0%
r	1439	4.0%
o	1439	4.0%
P	1	< 0.1%
a	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	35756	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	9999	28.0%
O	8560	23.9%
S	8560	23.9%
d	2879	8.1%
A	1439	4.0%
n	1439	4.0%
r	1439	4.0%
o	1439	4.0%
P	1	< 0.1%
a	1	< 0.1%

remaining_mileage
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED

Distinct	258
Distinct (%)	3.1%
Missing	1739
Missing (%)	17.4%
Infinite	0
Infinite (%)	0.0%
Mean	561.40266

Minimum	0
Maximum	64131
Zeros	65
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	162
Q1	342
median	472
Q3	588
95-th percentile	800
Maximum	64131
Range	64131
Interquartile range (IQR)	246

Descriptive statistics

Standard deviation	1668.7024
Coefficient of variation (CV)	2.9723806
Kurtosis	893.06205
Mean	561.40266
Median Absolute Deviation (MAD)	122
Skewness	28.480815
Sum	4637186
Variance	2784567.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
600	218	2.2%
528	135	1.4%
432	133	1.3%
504	128	1.3%
480	121	1.2%
594	121	1.2%
408	104	1.0%
492	103	1.0%
384	100	1.0%
456	98	1.0%
Other values (248)	6999	70.0%
(Missing)	1739	17.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	65	0.7%
8	2	< 0.1%
16	1	< 0.1%
18	1	< 0.1%
24	2	< 0.1%
32	1	< 0.1%
36	1	< 0.1%
40	7	0.1%
48	6	0.1%
54	3	< 0.1%

Value	Count	Frequency (%)
64131	1	< 0.1%
62145	1	< 0.1%
52705	1	< 0.1%
50429	1	< 0.1%
44688	1	< 0.1%
43231	1	< 0.1%
42770	1	< 0.1%
35227	1	< 0.1%
27373	1	< 0.1%
27177	1	< 0.1%

versions_battery_firmware
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	15
Distinct (%)	0.2%
Missing	2026
Missing (%)	20.3%
Memory size	78.2 KiB

1.0.6.0	4031
0.3.3.0	1963
1.0.3.0	1074
0.3.2.0	491
1.0.2.0	205
Other values (10)	209

Length

Max length	11
Median length	7
Mean length	7.0016305
Min length	7

Characters and Unicode

Total characters	55824
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	0.3.3.0
2nd row	0.3.3.0
3rd row	1.0.6.0
4th row	1.0.6.0
5th row	1.0.6.0

Common Values

Value	Count	Frequency (%)
1.0.6.0	4031	40.3%
0.3.3.0	1963	19.6%
1.0.3.0	1074	10.7%
0.3.2.0	491	4.9%
1.0.2.0	205	2.1%
0.0.0.0	141	1.4%
0.3.1.0	31	0.3%
1.0.1.0	17	0.2%
0.2.2.0	8	0.1%
0.2.6.0	5	0.1%
Other values (5)	7	0.1%
(Missing)	2026	20.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1.0.6.0	4031	50.6%
0.3.3.0	1963	24.6%
1.0.3.0	1074	13.5%
0.3.2.0	491	6.2%
1.0.2.0	205	2.6%
0.0.0.0	141	1.8%
0.3.1.0	31	0.4%
1.0.1.0	17	0.2%
0.2.2.0	8	0.1%
0.2.6.0	5	0.1%
Other values (5)	7	0.1%

Most occurring characters

Value	Count	Frequency (%)
.	23919	42.8%
0	16226	29.1%
3	5522	9.9%
1	5379	9.6%
6	4036	7.2%
2	720	1.3%
5	11	< 0.1%
4	8	< 0.1%
8	2	< 0.1%
9	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	31905	57.2%
Other Punctuation	23919	42.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16226	50.9%
3	5522	17.3%
1	5379	16.9%
6	4036	12.7%
2	720	2.3%
5	11	< 0.1%
4	8	< 0.1%
8	2	< 0.1%
9	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	23919	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	55824	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	23919	42.8%
0	16226	29.1%
3	5522	9.9%
1	5379	9.6%
6	4036	7.2%
2	720	1.3%
5	11	< 0.1%
4	8	< 0.1%
8	2	< 0.1%
9	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	55824	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	23919	42.8%
0	16226	29.1%
3	5522	9.9%
1	5379	9.6%
6	4036	7.2%
2	720	1.3%
5	11	< 0.1%
4	8	< 0.1%
8	2	< 0.1%
9	1	< 0.1%

versions_hmi_firmware
Categorical

HIGH CORRELATION MISSING

Distinct	9
Distinct (%)	0.1%
Missing	2026
Missing (%)	20.3%
Memory size	78.2 KiB

65.1.39.34	2305
1.7.18.0	1890
1.7.28.0	1604
1.2.18.0	1419
1.2.28.0	739
Other values (4)	16

Length

Max length	10
Median length	8
Mean length	8.5812116
Min length	8

Characters and Unicode

Total characters	68418
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	1.7.18.0
2nd row	1.7.18.0
3rd row	1.7.28.0
4th row	65.1.39.34
5th row	65.1.39.34

Common Values

Value	Count	Frequency (%)
65.1.39.34	2305	23.1%
1.7.18.0	1890	18.9%
1.7.28.0	1604	16.0%
1.2.18.0	1419	14.2%
1.2.28.0	739	7.4%
65.1.20.34	9	0.1%
1.7.20.0	4	< 0.1%
65.1.21.34	2	< 0.1%
65.1.27.34	1	< 0.1%
(Missing)	2026	20.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
65.1.39.34	2305	28.9%
1.7.18.0	1890	23.7%
1.7.28.0	1604	20.1%
1.2.18.0	1419	17.8%
1.2.28.0	739	9.3%
65.1.20.34	9	0.1%
1.7.20.0	4	0.1%
65.1.21.34	2	< 0.1%
65.1.27.34	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
.	23919	35.0%
1	11284	16.5%
0	5669	8.3%
8	5652	8.3%
3	4622	6.8%
2	4517	6.6%
7	3499	5.1%
6	2317	3.4%
5	2317	3.4%
4	2317	3.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	44499	65.0%
Other Punctuation	23919	35.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	11284	25.4%
0	5669	12.7%
8	5652	12.7%
3	4622	10.4%
2	4517	10.2%
7	3499	7.9%
6	2317	5.2%
5	2317	5.2%
4	2317	5.2%
9	2305	5.2%

Other Punctuation

Value	Count	Frequency (%)
.	23919	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	68418	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	23919	35.0%
1	11284	16.5%
0	5669	8.3%
8	5652	8.3%
3	4622	6.8%
2	4517	6.6%
7	3499	5.1%
6	2317	3.4%
5	2317	3.4%
4	2317	3.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	68418	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	23919	35.0%
1	11284	16.5%
0	5669	8.3%
8	5652	8.3%
3	4622	6.8%
2	4517	6.6%
7	3499	5.1%
6	2317	3.4%
5	2317	3.4%
4	2317	3.4%

versions_hmi_hardware
Categorical

HIGH CORRELATION MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	2026
Missing (%)	20.3%
Memory size	78.2 KiB

1.0	3498
2.0	2317
0.0	2158

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	23919
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	2.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
1.0	3498	35.0%
2.0	2317	23.2%
0.0	2158	21.6%
(Missing)	2026	20.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	3498	43.9%
2.0	2317	29.1%
0.0	2158	27.1%

Most occurring characters

Value	Count	Frequency (%)
0	10131	42.4%
.	7973	33.3%
1	3498	14.6%
2	2317	9.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	15946	66.7%
Other Punctuation	7973	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	10131	63.5%
1	3498	21.9%
2	2317	14.5%

Other Punctuation

Value	Count	Frequency (%)
.	7973	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	23919	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	10131	42.4%
.	7973	33.3%
1	3498	14.6%
2	2317	9.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	23919	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	10131	42.4%
.	7973	33.3%
1	3498	14.6%
2	2317	9.7%

Auto

Heatmap
Table

	total_mileage	assist_level	battery_error_state	battery_state_battery_soc	battery_state_battery_soh	battery_state_cell_temp_1	battery_state_cell_temp_2	battery_state_chg_temp	battery_state_dsg_temp	battery_state_full_capacity	battery_state_pack_voltage	battery_state_pre_start_temp	battery_state_real_time_current	battery_state_remaining_capacity	remaining_mileage	versions_mc_firmware	dance_area	os_name	versions_battery_firmware	versions_hmi_firmware	versions_hmi_hardware
total_mileage	1.000	0.020	-0.081	-0.031	-0.350	-0.137	-0.139	-0.148	-0.149	-0.273	-0.033	-0.150	0.066	-0.154	0.003	0.000	0.000	0.000	0.000	0.000	0.047
assist_level	0.020	1.000	-0.081	0.002	-0.042	0.044	0.043	0.059	0.058	-0.004	-0.067	0.057	-0.111	0.040	-0.383	0.000	0.000	0.014	0.000	0.086	0.049
battery_error_state	-0.081	-0.081	1.000	0.026	0.021	-0.025	-0.028	-0.024	-0.023	-0.026	0.045	-0.022	0.087	-0.015	-0.078	0.633	0.000	0.000	0.194	0.015	0.028
battery_state_battery_soc	-0.031	0.002	0.026	1.000	0.025	-0.023	-0.023	-0.021	-0.021	0.006	0.678	-0.020	0.128	0.326	0.823	0.081	0.013	0.066	0.050	0.015	0.026
battery_state_battery_soh	-0.350	-0.042	0.021	0.025	1.000	0.004	0.008	0.010	0.011	0.352	0.011	0.012	-0.007	0.074	0.012	0.207	0.050	0.028	0.133	0.023	0.021
battery_state_cell_temp_1	-0.137	0.044	-0.025	-0.023	0.004	1.000	0.997	0.983	0.983	0.776	-0.035	0.982	-0.211	0.784	-0.033	0.000	0.059	1.000	0.393	0.456	0.475
battery_state_cell_temp_2	-0.139	0.043	-0.028	-0.023	0.008	0.997	1.000	0.982	0.982	0.777	-0.037	0.982	-0.212	0.783	-0.034	0.000	0.058	1.000	0.391	0.453	0.473
battery_state_chg_temp	-0.148	0.059	-0.024	-0.021	0.010	0.983	0.982	1.000	1.000	0.778	-0.045	1.000	-0.224	0.783	-0.039	0.000	0.079	1.000	0.397	0.466	0.402
battery_state_dsg_temp	-0.149	0.058	-0.023	-0.021	0.011	0.983	0.982	1.000	1.000	0.778	-0.046	1.000	-0.224	0.783	-0.039	0.000	0.079	1.000	0.397	0.466	0.402
battery_state_full_capacity	-0.273	-0.004	-0.026	0.006	0.352	0.776	0.777	0.778	0.778	1.000	-0.029	0.778	-0.177	0.816	-0.001	0.039	0.071	1.000	0.633	0.703	0.454
battery_state_pack_voltage	-0.033	-0.067	0.045	0.678	0.011	-0.035	-0.037	-0.045	-0.046	-0.029	1.000	-0.047	0.227	0.280	0.578	0.400	0.027	0.985	0.196	0.052	0.071
battery_state_pre_start_temp	-0.150	0.057	-0.022	-0.020	0.012	0.982	0.982	1.000	1.000	0.778	-0.047	1.000	-0.223	0.783	-0.040	0.000	0.079	1.000	0.397	0.466	0.402
battery_state_real_time_current	0.066	-0.111	0.087	0.128	-0.007	-0.211	-0.212	-0.224	-0.224	-0.177	0.227	-0.223	1.000	-0.160	0.133	0.000	0.030	0.016	0.000	0.038	0.086
battery_state_remaining_capacity	-0.154	0.040	-0.015	0.326	0.074	0.784	0.783	0.783	0.783	0.816	0.280	0.783	-0.160	1.000	0.248	0.000	0.060	1.000	0.305	0.404	0.446
remaining_mileage	0.003	-0.383	-0.078	0.823	0.012	-0.033	-0.034	-0.039	-0.039	-0.001	0.578	-0.040	0.133	0.248	1.000	0.000	0.000	0.000	0.000	0.000	0.032
versions_mc_firmware	0.000	0.000	0.633	0.081	0.207	0.000	0.000	0.000	0.000	0.039	0.400	0.000	0.000	0.000	0.000	1.000	0.039	0.038	0.190	0.035	0.052
dance_area	0.000	0.000	0.000	0.013	0.050	0.059	0.058	0.079	0.079	0.071	0.027	0.079	0.030	0.060	0.000	0.039	1.000	0.034	0.177	0.205	0.298
os_name	0.000	0.014	0.000	0.066	0.028	1.000	1.000	1.000	1.000	1.000	0.985	1.000	0.016	1.000	0.000	0.038	0.034	1.000	0.095	0.105	0.079
versions_battery_firmware	0.000	0.000	0.194	0.050	0.133	0.393	0.391	0.397	0.397	0.633	0.196	0.397	0.000	0.305	0.000	0.190	0.177	0.095	1.000	0.586	0.405
versions_hmi_firmware	0.000	0.086	0.015	0.015	0.023	0.456	0.453	0.466	0.466	0.703	0.052	0.466	0.038	0.404	0.000	0.035	0.205	0.105	0.586	1.000	1.000
versions_hmi_hardware	0.047	0.049	0.028	0.026	0.021	0.475	0.473	0.402	0.402	0.454	0.071	0.402	0.086	0.446	0.032	0.052	0.298	0.079	0.405	1.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	vehicle_id	user_id	total_mileage	versions_mc_firmware	occurred_at_time	app_version	assist_level	battery_cells	battery_serial_number	battery_state_battery_soc	battery_state_battery_soh	battery_state_cell_temp_1	battery_state_cell_temp_2	battery_state_chg_temp	battery_state_dsg_temp	battery_state_full_capacity	battery_state_pack_voltage	battery_state_pre_start_temp	battery_state_real_time_current	battery_state_remaining_capacity	dance_area	event	hmi_serial_number	os_name	remaining_mileage	versions_battery_firmware	versions_hmi_firmware	versions_hmi_hardware
0	bc3412f7-37a8-4676-8043-53f4a1bb316a	ca73adbe-5930-45ba-af74-de5865d8b093	7281.0	DA210815.10	2023-04-05 08:54:50	2023.03.24-3923-prod-release	0.0	[null,null,null,null,null,null,null,null,null,null]	HT1002MA121521183	65.0	98.0	0.0	0.0	0.0	0.0	0.0	38925.0	0.0	-60.0	0.0	PARIS	Vehicle Connected	60968A	Android	1300.0	0.3.3.0	1.7.18.0	1.0
1	95e7ee01-3987-481a-9000-3b331c52192f	6560e385-b90d-42be-b977-5cdb3a5d5a60	NaN	NaN	2022-09-05 18:13:47	2022.8.26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	PARIS	Vehicle Connected	NaN	iOS	NaN	NaN	NaN	NaN
2	c63d60f2-5e2a-483c-bb11-935c45ebf2f0	118047dc-bf44-4dc0-9862-0cb3ac5db65d	1185.0	DA210815.10	2023-09-10 12:22:06	2023.9.4	1.0	NaN	NaN	89.0	94.0	NaN	NaN	NaN	NaN	NaN	-24763.0	NaN	-30.0	NaN	BERLIN	Vehicle Connected	2C139F	iOS	712.0	0.3.3.0	1.7.18.0	1.0
3	79df825d-8115-4a84-9aa8-87ae307ae561	f0c0ac6d-32a1-45ed-9de1-466455fa637a	378.0	DA210815.10	2022-09-14 07:50:05	2022.08.30-3095-prod-release	2.0	[3997,3997,4001,3994,4000,4013,4014,4015,4009,4012]	HT1002MA121251821	79.0	99.0	17.0	17.0	17.0	17.0	9468.0	40052.0	17.0	-107.0	7479.0	BERLIN	Vehicle Connected	73D58B	Android	474.0	1.0.6.0	1.7.28.0	1.0
4	0d30c889-a102-4bdc-b8a3-c1e0d6c536d5	2b9f8b3f-b3f3-409b-ade0-dd9ae8b54ba7	NaN	NaN	2022-09-12 14:12:19	2022.8.29	NaN	NaN	4854313030324d41313231353231373236000000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	HAMBURG	Vehicle Connected	NaN	iOS	NaN	NaN	NaN	NaN
5	5c1e2a7b-afc5-482d-96d0-12c2f938e712	a3afa394-cf40-450a-b323-a1d23d685f38	NaN	NaN	2022-09-11 17:14:15	2022.8.29	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	PARIS	Vehicle Connected	NaN	iOS	NaN	NaN	NaN	NaN
6	2d31a77f-26ad-4f92-bd9f-a44d2ad79c89	8c169cd9-274d-4025-9dd9-bc762f8b385d	1135.0	DA210815.10	2023-07-26 07:00:22	2023.7.20	2.0	NaN	HT1002MA122120371HT1002MA122120371HT1002MA122120371HT1002MA122120371HT1002MA122120371	95.0	99.0	NaN	NaN	NaN	NaN	NaN	-24776.0	NaN	-2603.0	NaN	PARIS	Vehicle Connected	22491134	iOS	570.0	1.0.6.0	65.1.39.34	2.0
7	a53f881c-af7b-4f32-bf8d-13eef013d4b1	4fe83c19-4de1-4dd0-97dc-4e5ae5850b2b	NaN	NaN	2022-11-05 07:16:31	2022.10.11	NaN	NaN	HT1002MA121340143	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	MUNICH	Vehicle Connected	89F0D3	iOS	NaN	NaN	NaN	NaN
8	d2ce3fbd-f352-42ce-bf6d-19abcac8db32	dd798684-8ff6-422c-9c42-a05b70dc6140	323.0	DA210815.10	2023-08-08 12:45:07	2023.08.04-4184-prod-release	1.0	[4081,4081,4082,4083,4081,4085,4083,4083,4085,4083]	HT1002MA12244004	92.0	99.0	25.0	25.0	25.0	25.0	9491.0	40829.0	25.0	-96.0	8700.0	PARIS	Vehicle Connected	23020758	Android	736.0	1.0.6.0	65.1.39.34	2.0
9	c88d33c5-c6a6-421a-9deb-9722c36b1617	6dcaf0ea-3b9d-4666-bd04-9661ce79cc44	11254.0	DA210815.10	2023-07-17 13:58:29	2023.07.06-4135-prod-release	2.0	[3913,3911,3911,3911,3911,3923,3921,3914,3923,3922]	HT1002MA12140156	68.0	91.0	33.0	32.0	34.0	34.0	8693.0	39164.0	34.0	-96.0	5901.0	BERLIN	Vehicle Connected	22510490	Android	408.0	0.3.3.0	65.1.39.34	2.0

	vehicle_id	user_id	total_mileage	versions_mc_firmware	occurred_at_time	app_version	assist_level	battery_cells	battery_serial_number	battery_state_battery_soc	battery_state_battery_soh	battery_state_cell_temp_1	battery_state_cell_temp_2	battery_state_chg_temp	battery_state_dsg_temp	battery_state_full_capacity	battery_state_pack_voltage	battery_state_pre_start_temp	battery_state_real_time_current	battery_state_remaining_capacity	dance_area	event	hmi_serial_number	os_name	remaining_mileage	versions_battery_firmware	versions_hmi_firmware	versions_hmi_hardware
9989	61a771fd-f11b-4144-8842-73ebd69471b8	04445577-ab03-46db-bd07-744d3c58f71c	105.0	DA210815.10	2023-08-31 16:16:55	2023.8.16	1.0	NaN	HT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\n	82.0	100.0	NaN	NaN	NaN	NaN	NaN	-25304.0	NaN	-74.0	NaN	PARIS	Vehicle Connected	23070809	iOS	656.0	1.0.6.0	65.1.39.34	2.0
9990	74015cd1-8b8d-40f2-92bd-9f7f17fd8831	2bec0841-17cf-4404-ae1c-852e5e375553	2806.0	DA210815.10	2022-10-20 12:00:33	2022.10.12	2.0	NaN	HT1002MA121402039	20.0	98.0	NaN	NaN	NaN	NaN	NaN	-30679.0	NaN	-65.0	NaN	PARIS	Vehicle Connected	87B451	iOS	120.0	0.3.2.0	1.7.18.0	1.0
9991	6eca4ad4-0aca-443a-954d-9983a9d1a7b0	725e1583-c2c3-47e3-ab91-3d2a6136e4b2	2431.0	DA210815.10	2023-05-01 18:32:53	2023.4.21	2.0	NaN	HT1002MA122260713	34.0	95.0	NaN	NaN	NaN	NaN	NaN	-29721.0	NaN	-6715.0	NaN	PARIS	Vehicle Connected	F179D7	iOS	204.0	1.0.3.0	1.7.18.0	1.0
9992	ca4c5d0d-0d08-4189-b8ee-e8cd4d337422	7d7c1e29-1a35-447c-b672-5899a55bc6f1	12411.0	DA210815.10	2022-08-30 18:59:02	2022.8.26	2.0	NaN	4854313030324d41313232303831383633000000	73.0	97.0	NaN	NaN	NaN	NaN	NaN	-26146.0	NaN	-57.0	NaN	PARIS	Vehicle Connected	324333373044	iOS	438.0	0.3.3.0	1.7.18.0	1.0
9993	6f700383-48f2-4aa7-9ede-d0437f90c09f	f4b7ecf1-5feb-4197-8bca-883513fc63af	8949.0	DA210815.10	2023-05-16 13:49:36	2023.3.17	2.0	NaN	HT1002MA121520495	85.0	98.0	NaN	NaN	NaN	NaN	NaN	-24992.0	NaN	-65.0	NaN	PARIS	Vehicle Connected	5F1807	iOS	510.0	0.3.3.0	1.7.28.0	1.0
9994	bd1e99fc-086e-4260-9cc4-f291d63002d9	b59b0854-5153-4e62-96df-db84293162cf	2713.0	DA210815.10	2023-07-07 07:22:27	2023.6.12	2.0	NaN	NaN	46.0	98.0	NaN	NaN	NaN	NaN	NaN	-30683.0	NaN	-11007.0	NaN	PARIS	Vehicle Connected	22510450	iOS	276.0	1.0.6.0	65.1.39.34	2.0
9995	89f28faa-77ef-4022-a767-86c8eeb42d2f	f958f248-e4cc-40c3-8e6b-d0e4b8429c46	21101.0	DA210815.10	2023-09-11 14:40:10	2023.9.4	2.0	NaN	NaN	73.0	96.0	NaN	NaN	NaN	NaN	NaN	-26271.0	NaN	-63.0	NaN	HAMBURG	Vehicle Connected	2CBE66	iOS	438.0	1.0.6.0	1.2.28.0	0.0
9996	d2e8184f-15d5-4765-84ab-feceeecf6c9e	ce60d719-e603-4c6b-b5d1-36f49cafd0a7	NaN	NaN	2022-12-07 07:24:14	2022.11.28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	HAMBURG	Vehicle Connected	NaN	iOS	NaN	NaN	NaN	NaN
9997	da69c76a-3c9a-4226-846b-996257559b72	2d8b3fd6-3e40-4674-8c47-d8450a9c3671	5505.0	DA210815.10	2023-03-09 19:26:15	2023.3.3	2.0	NaN	HT1002MA121400838	82.0	98.0	NaN	NaN	NaN	NaN	NaN	-25513.0	NaN	-60.0	NaN	PARIS	Vehicle Connected	64AC8B	iOS	492.0	0.3.2.0	1.7.18.0	1.0
9998	ce3f2756-3d57-4e03-abfd-d4df018f39a0	f1ed0715-e3ff-4e47-8c94-51bd61063e99	NaN	NaN	2023-01-20 12:45:46	2023.1.11	NaN	NaN	HT1002MA121220008	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	HAMBURG	Vehicle Connected	63316E	iOS	NaN	NaN	NaN	NaN

Most frequently occurring

	vehicle_id	user_id	total_mileage	versions_mc_firmware	occurred_at_time	app_version	assist_level	battery_cells	battery_serial_number	battery_state_battery_soc	battery_state_battery_soh	battery_state_cell_temp_1	battery_state_cell_temp_2	battery_state_chg_temp	battery_state_dsg_temp	battery_state_full_capacity	battery_state_pack_voltage	battery_state_pre_start_temp	battery_state_real_time_current	battery_state_remaining_capacity	dance_area	event	hmi_serial_number	os_name	remaining_mileage	versions_battery_firmware	versions_hmi_firmware	versions_hmi_hardware	# duplicates
0	019e70dd-64f0-4527-9aff-e09ef5743dd0	6afca364-1442-4920-8e10-68930b1f112a	9483.0	DA210815.10	2023-08-27 15:34:20	2023.8.16	2.0	NaN	HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817	37.0	98.0	NaN	NaN	NaN	NaN	NaN	-30699.0	NaN	-5405.0	NaN	PARIS	Vehicle Connected	22511089	iOS	222.0	1.0.6.0	65.1.39.34	2.0	2
1	c1942627-dc25-4d5f-8c5e-8179a2de72d7	1ed581fe-31e1-4869-98e4-4cc18c9aeffa	2139.0	DA210815.10	2023-06-20 17:50:17	2023.6.12	2.0	NaN	HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT	40.0	99.0	NaN	NaN	NaN	NaN	NaN	-29384.0	NaN	-98.0	NaN	PARIS	Vehicle Connected	B808D4	iOS	240.0	1.0.6.0	1.7.28.0	1.0	2
2	fd878446-1c44-4a9f-b88f-10ce83cade59	d453aad8-6c95-425a-8a63-f9fe012554f8	16985.0	DA210815.10	2023-06-20 15:37:03	2023.6.12	1.0	NaN	NaN	31.0	98.0	NaN	NaN	NaN	NaN	NaN	-30029.0	NaN	-65.0	NaN	BERLIN	Vehicle Connected	48C70B	iOS	248.0	1.0.3.0	1.7.18.0	1.0	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Arabic

Latin

Most occurring blocks

Most frequent character per block

ASCII

Arabic

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block